home *** CD-ROM | disk | FTP | other *** search
/ Windows Expert / Windows Expert.iso / program / winsql.zip / EXAMPLES.ZIP / QUERY11.SQL < prev    next >
Text File  |  1991-04-25  |  88b  |  2 lines

  1. select sname from s where exists
  2.   (select * from sp where sno = s.sno and pno = 'P2');